drop table

When you drop a table, dropping the table's triggers should be automatic.

删除表的时候没有自动删除触发器。

provided by jukuu

This example show you how to CREATE a Table and DROP a Table using ADO.

这个例子演示了如何创建一个表,以及使用ADO处理表.

网络文摘精选

To add a metric or dimension to the report, simply drag and drop it into the table.

要添加公制或层面的报告，只要拖放到桌子上。

互联网摘选

After copying all rows in table SALES successfully to table SALES_TMP, the source table SALES can be dropped ( DROP TABLE statement).

在把SALES表中的所有行成功地复制到SALES TMP表之后，可以删除源表（DROP TABLE语句）。

互联网摘选

With these two buttons and the drop-down ComboBox, you can retrieve the list of tablenames from the IBM DB2 UDB database you're connected to, and drop the selected table at will.

使用这两个按钮和下拉式ComboBox，可以从连接的IBM DB2UDB数据库中检索表名的列表，并自由删除选中的表。

互联网摘选

Note that the debugger might generate warnings related to DROP TABLE statements, which you can ignore.

注意，调试器可能会产生与DROP TABLE语句有关的警告，可以不理会它。

互联网摘选

Your database user needs quite a lot database permissions, including alter table, drop table, same for index etc.

数据库用户需要相当多的权限，包括修改表格，放下表格，索引一类的也一样。

互联网摘选

The script includes commented drop statements that users can uncomment to drop the table.

该脚本包括已注释掉的撤销语句，用户可以取消对表的撤销。

互联网摘选

If you need to drop all tables before you start fresh, you can select the drop table script and execute it.

如果需要在开始刷新之前删除所有表，可以选择并执行删除表脚本。

互联网摘选

The only restriction when running an online backup in DB2 is that you cannot drop a table space while that table space is actively being backed up.

在DB2中运行在线备份的惟一约束是：当一个表空间正在被备份的时候，不能删除这个表空间。

互联网摘选

Database explorer for drag and drop database development and table modification.

数据库Explorer用于数据库开发和表格修正中的拖放.

互联网摘选

Drop the existing table and re-create it.

除去现有表并重新创建该表。

provided by jukuu

Determine if you have sufficient access permission to drop the specified table.

确定您是否有足够的访问权限丢弃指定的表。

provided by jukuu

Finally, the DROP TABLE statement deletes the empty table from the schema.

最后，DROP TABLE语句删除模式中的空表。

互联网摘选

Drop by my table later.

待会到我的桌子那坐坐。

provided by jukuu

If you're indoors, get away from windows, drop under a sturdy table, desk or other protective area and cover your head with a pillow.

如果你在室内，请务必远离窗户，躲在牢固的桌子、凳子或其它有防护物体的区域下，并用枕头保护你的头部。

互联网摘选

To create the table at runtime, set the Table action to drop and recreate the table.

为了在运行时创建表，请设置Table操作来拖放并重新创建表。

互联网摘选

The only way to change this relationship is to drop the table and recreate it in a different table space that is tied to a different database partition group.

更改此关系的惟一方式是丢弃此表并在与不同的数据库分区组相关联的一个不同的表空间内重新创建它。

互联网摘选

Text Form Field; Label; Group Box; Drop-down Form Field; Draw Table; Insert Table; Protect Form

文本表单字段；标签；分组框；下拉表单字段；绘制表；插入表；保护表单

互联网摘选

Database explorer for drag and drop database development and table modification

数据库Explorer用于数据库开发和表格修正中的拖放

互联网摘选

The merge process could not drop the retry table.

合并进程无法删除重试表。

provided by jukuu

To disable an index, you must first drop the table from the publication.

若要禁用索引，必须先从发布中删除该表。

provided by jukuu

Additional solutions, depending on the errors, may be to manually rebuild non-clustered indexes, manually drop and reload a table if the data is static, and so on.

另外的解决方案，取决于具体的错误，可能是手工重建非聚簇索引，如果数据是静态的手工扔掉和重新载入表，诸如此类。

互联网摘选

You create a Statement to execute commands to drop and recreate the table, which allows you to reset the database from this program if it becomes corrupted.

创建一个Statement来执行删除和重新创建表的命令，这允许您在数据库受损时通过此程序重置数据库。

互联网摘选

If you've already populated your Clients table, you might find it convenient to delete its contents or drop and recreate the table.

如果已经填充了Clients表，那么您可能会发现可以很方便地删除它的内容或销毁并重新创建表。

互联网摘选

The syntax is simple: You append the fully qualified name and a semicolon to the DROP TABLE SQL command, and you're finished.

语法很简单：把完全限定名称和分号放在DROP TABLE SQL命令后面，就完成了。

互联网摘选

This same technique might be used to execute a DROP TABLE statement or to execute a system stored procedure that created a new user account and added that user to the sysadmin role.

这一技术可能会被用来执行DROP TABLE语句，或执行创建新用户帐户并将该用户添加到sysadmin角色的系统存储过程。

互联网摘选

The SQL syntax to delete a table is DROP TABLE followed by the tablename.

删除表的SQL语法是DROP TABLE，这之后是表名。

互联网摘选

Replace& to drop the existing table and then create a new table

替换&放弃已有表并创建一个新表

互联网摘选

Then use the Drop Table button to drop the table from the database, by adding the selected tablename to the "DROP TABLE" string, as follows

将选定的表名添加到“DROP TABLE”字符串中，然后使用Drop Table按钮从数据库中删除该表，如下所示

互联网摘选